use "Validation_zone.dta", clear

*Table A6
corr spei rain if yeart==1987
corr spei rain if yeart==2000
corr spei rain if yeart==2002

*Table A7
reg spei rain i.month if yeart==1987, cluster(id) 
reg spei rain if yeart==2000, cluster(id)
reg spei rain i.month if yeart==2002, cluster(id)

*Table A8
use "Validation_dist.dta", clear
xi:reg mean_d_cspei prec i.year i.State_code2001, r cluster(dist_name)
xi:reg mean_d_cspei prec i.month i.year i.State_code2001, r cluster(dist_name)
xi:reg mean_d_cspei prec i.year i.dist_name, r cluster(dist_name)
xi:reg mean_d_cspei prec i.month i.year i.dist_name, r cluster(dist_name)
